I am new to Power BI
below are a data for reference :
Have created slicer on project names and few cards (LE-Approved budget,variance & variance %)
If i select a specific project name , it gives the correct sum for the respective field , but suppose if no project is selected it will give a sum in respective cards which is correct for respective projects but For variation % card (when no individual project is selected) instead of total sum (100%) need to have the result of Variance /Approved budget (4%).
below are a data for reference :
Have created slicer on project names and few cards (LE-Approved budget,variance & variance %)
| Project | LE | Approved budget | Variance | Variance % |
| A | 879000 | 700000 | 179000 | 26% |
| b | 388999 | 380000 | 8999 | 2% |
| c | 138522.5 | 200000 | -61477.5 | -31% |
| d | 300799 | 150000 | 150799 | 101% |
| e | 3470000 | 3500000 | -30000 | -1% |
| f | 2000000 | 2000000 | 0 | 0% |
| total | 7177320.5 | 6930000 | 247320.5 | 4% |
