help please

[Zakaria_1980]

Hi,

please I need your support. i have integrated some Data into PBI and i succedded to get the same view below that i get from Excel, but the question here, is there any possibility to replace all the 1 with Due and keep the total per LM and per Country counting the number of Due ?

Thanks in advance.

[Anonymous]

@Zakaria_1980 

You can create a measure: 

2020part1 = IF(HASONEVALUE('Table'[Email]),"Due",COUNT('Table'[2021-part1]))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Zakaria_1980 , You can use isinscope to switch total

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

But I am not fully sure what you want. Can you share sample data and sample output in table format?