Hello @Dharma,
It’s not a big deal. You can do that by putting a measure inside a filter pane by selecting the Function slicer and put the condition as “Total Budgets > 0”. Below is the screenshot provided for the reference -
Once you do this, now you’ll see only “HR” and “IT” as a result for “India”. Below is the screenshot provided for the reference -
The reason why I converted the flat file into a data model is because firstly, it’s a recommended best practice and secondly, it’s helpful in the case of advanced or complex calculations. One such example was witnessed recently onto the forum where flat file had to be converted into a proper data model to achieve the results. Below is the link of that post provided for the reference.
It’s your choice whether to go with the flat file or with the proper data model.
I’m also attaching the working PBIX file for the reference purposes.
Thanks and Warm Regards,
Harsh
Budget - Harsh v3.pbix (26.9 KB)